﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'SearchTelefono')
	BEGIN
		DROP  Procedure  SearchTelefono
	END
GO

CREATE Procedure SearchTelefono

	@numero nvarchar(10)

AS

BEGIN

	SELECT * FROM Telefono WHERE Telefono.NroCelular LIKE @numero+'%'

END

GO


GRANT EXEC ON SearchTelefono TO PUBLIC

GO

